Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 180519 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 127.2 MiB |
| Average record size in memory | 738.6 B |
Variable types
| DateTime | 2 |
|---|---|
| Categorical | 8 |
| Numeric | 8 |
| Text | 4 |
delivery_status is highly overall correlated with late_delivery_risk and 2 other fields | High correlation |
discount is highly overall correlated with discount_rate and 1 other fields | High correlation |
discount_rate is highly overall correlated with discount | High correlation |
late_delivery_risk is highly overall correlated with delivery_status and 1 other fields | High correlation |
order_status is highly overall correlated with delivery_status | High correlation |
product_price is highly overall correlated with sales_actual and 1 other fields | High correlation |
sales_actual is highly overall correlated with product_price and 1 other fields | High correlation |
sales_origin is highly overall correlated with discount and 2 other fields | High correlation |
shipping_days_actual is highly overall correlated with delivery_status and 3 other fields | High correlation |
shipping_days_scheduled is highly overall correlated with shipping_days_actual and 1 other fields | High correlation |
shipping_mode is highly overall correlated with shipping_days_actual and 1 other fields | High correlation |
shipping_days_actual has 5080 (2.8%) zeros | Zeros |
discount has 10028 (5.6%) zeros | Zeros |
discount_rate has 10028 (5.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-05-05 16:17:38.060093 |
|---|---|
| Analysis finished | 2025-05-05 16:18:09.850241 |
| Duration | 31.79 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
order_date
Date
| Distinct | 1127 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Minimum | 2015-01-01 00:00:00 |
|---|---|
| Maximum | 2018-01-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
shipping_date
Date
| Distinct | 1131 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Minimum | 2015-01-03 00:00:00 |
|---|---|
| Maximum | 2018-02-06 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
shipping_mode
Categorical
High correlation 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.0 MiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 9737 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.823969 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Standard Class |
|---|---|
| 2nd row | Standard Class |
| 3rd row | Standard Class |
| 4th row | Standard Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 107752 | |
| Second Class | 35216 | 19.5% |
| First Class | 27814 | 15.4% |
| Same Day | 9737 | 5.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 170782 | |
| standard | 107752 | |
| second | 35216 | 9.8% |
| first | 27814 | 7.7% |
| same | 9737 | 2.7% |
| day | 9737 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 405760 | |
| s | 369378 | |
| d | 250720 | |
| 180519 | ||
| l | 170782 | |
| C | 170782 | |
| S | 152705 | 6.6% |
| n | 142968 | 6.2% |
| r | 135566 | 5.9% |
| t | 135566 | 5.9% |
| Other values (8) | 200224 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2314970 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 405760 | |
| s | 369378 | |
| d | 250720 | |
| 180519 | ||
| l | 170782 | |
| C | 170782 | |
| S | 152705 | 6.6% |
| n | 142968 | 6.2% |
| r | 135566 | 5.9% |
| t | 135566 | 5.9% |
| Other values (8) | 200224 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2314970 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 405760 | |
| s | 369378 | |
| d | 250720 | |
| 180519 | ||
| l | 170782 | |
| C | 170782 | |
| S | 152705 | 6.6% |
| n | 142968 | 6.2% |
| r | 135566 | 5.9% |
| t | 135566 | 5.9% |
| Other values (8) | 200224 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2314970 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 405760 | |
| s | 369378 | |
| d | 250720 | |
| 180519 | ||
| l | 170782 | |
| C | 170782 | |
| S | 152705 | 6.6% |
| n | 142968 | 6.2% |
| r | 135566 | 5.9% |
| t | 135566 | 5.9% |
| Other values (8) | 200224 |
delivery_status
Categorical
High correlation 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.3 MiB |
| Late delivery | |
|---|---|
| Advance shipping | |
| Shipping on time | |
| Shipping canceled | 7754 |
Length
| Max length | 17 |
|---|---|
| Median length | 13 |
| Mean length | 14.39808 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Advance shipping |
|---|---|
| 2nd row | Late delivery |
| 3rd row | Shipping on time |
| 4th row | Advance shipping |
| 5th row | Advance shipping |
Common Values
| Value | Count | Frequency (%) |
| Late delivery | 98977 | |
| Advance shipping | 41592 | |
| Shipping on time | 32196 | 17.8% |
| Shipping canceled | 7754 | 4.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| late | 98977 | |
| delivery | 98977 | |
| shipping | 81542 | |
| advance | 41592 | |
| on | 32196 | 8.2% |
| time | 32196 | 8.2% |
| canceled | 7754 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 386227 | |
| i | 294257 | |
| 212715 | 8.2% | |
| n | 163084 | 6.3% |
| p | 163084 | 6.3% |
| d | 148323 | 5.7% |
| a | 148323 | 5.7% |
| v | 140569 | 5.4% |
| t | 131173 | 5.0% |
| l | 106731 | 4.1% |
| Other values (11) | 704641 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2599127 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 386227 | |
| i | 294257 | |
| 212715 | 8.2% | |
| n | 163084 | 6.3% |
| p | 163084 | 6.3% |
| d | 148323 | 5.7% |
| a | 148323 | 5.7% |
| v | 140569 | 5.4% |
| t | 131173 | 5.0% |
| l | 106731 | 4.1% |
| Other values (11) | 704641 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2599127 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 386227 | |
| i | 294257 | |
| 212715 | 8.2% | |
| n | 163084 | 6.3% |
| p | 163084 | 6.3% |
| d | 148323 | 5.7% |
| a | 148323 | 5.7% |
| v | 140569 | 5.4% |
| t | 131173 | 5.0% |
| l | 106731 | 4.1% |
| Other values (11) | 704641 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2599127 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 386227 | |
| i | 294257 | |
| 212715 | 8.2% | |
| n | 163084 | 6.3% |
| p | 163084 | 6.3% |
| d | 148323 | 5.7% |
| a | 148323 | 5.7% |
| v | 140569 | 5.4% |
| t | 131173 | 5.0% |
| l | 106731 | 4.1% |
| Other values (11) | 704641 |
shipping_days_actual
Real number (ℝ)
High correlation  Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.497654 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 5080 |
| Zeros (%) | 2.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.6237218 |
|---|---|
| Coefficient of variation (CV) | 0.46423169 |
| Kurtosis | -1.0079136 |
| Mean | 3.497654 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.084771273 |
| Sum | 631393 |
| Variance | 2.6364726 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 56618 | |
| 3 | 28765 | |
| 6 | 28723 | |
| 4 | 28513 | |
| 5 | 28163 | |
| 0 | 5080 | 2.8% |
| 1 | 4657 | 2.6% |
| Value | Count | Frequency (%) |
| 0 | 5080 | 2.8% |
| 1 | 4657 | 2.6% |
| 2 | 56618 | |
| 3 | 28765 | |
| 4 | 28513 | |
| 5 | 28163 | |
| 6 | 28723 |
| Value | Count | Frequency (%) |
| 6 | 28723 | |
| 5 | 28163 | |
| 4 | 28513 | |
| 3 | 28765 | |
| 2 | 56618 | |
| 1 | 4657 | 2.6% |
| 0 | 5080 | 2.8% |
shipping_days_scheduled
Categorical
High correlation 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.0 MiB |
| 4 | |
|---|---|
| 2 | |
| 1 | |
| 0 | 9737 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 4 |
| 3rd row | 4 |
| 4th row | 4 |
| 5th row | 4 |
Common Values
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 180519 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 180519 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 180519 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
late_delivery_risk
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.0 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 180519 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 180519 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 180519 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
sales_origin
Real number (ℝ)
High correlation 
| Distinct | 193 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203.7721 |
| Minimum | 9.99 |
|---|---|
| Maximum | 1999.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 9.99 |
|---|---|
| 5-th percentile | 49.98 |
| Q1 | 119.98 |
| median | 199.92 |
| Q3 | 299.95001 |
| 95-th percentile | 399.98001 |
| Maximum | 1999.99 |
| Range | 1990 |
| Interquartile range (IQR) | 179.97001 |
Descriptive statistics
| Standard deviation | 132.27308 |
|---|---|
| Coefficient of variation (CV) | 0.64912262 |
| Kurtosis | 23.936562 |
| Mean | 203.7721 |
| Median Absolute Deviation (MAD) | 79.94 |
| Skewness | 2.8842491 |
| Sum | 36784735 |
| Variance | 17496.167 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 129.99001 | 22372 | 12.4% |
| 399.98001 | 17325 | 9.6% |
| 199.99001 | 15622 | 8.7% |
| 299.98001 | 13729 | 7.6% |
| 179.97 | 5016 | 2.8% |
| 299.95001 | 4988 | 2.8% |
| 119.98 | 4968 | 2.8% |
| 239.96001 | 4955 | 2.7% |
| 59.99 | 4893 | 2.7% |
| 50 | 4432 | 2.5% |
| Other values (183) | 82219 |
| Value | Count | Frequency (%) |
| 9.99 | 56 | < 0.1% |
| 11.29 | 271 | |
| 11.54 | 529 | |
| 14.99 | 124 | 0.1% |
| 15.99 | 118 | 0.1% |
| 17.99 | 62 | < 0.1% |
| 19.98 | 54 | < 0.1% |
| 19.99 | 176 | 0.1% |
| 21.99 | 51 | < 0.1% |
| 22 | 64 | < 0.1% |
| Value | Count | Frequency (%) |
| 1999.98999 | 15 | < 0.1% |
| 1500 | 442 | 0.2% |
| 999.98999 | 10 | < 0.1% |
| 599.98999 | 21 | < 0.1% |
| 532.58002 | 484 | 0.3% |
| 500 | 15 | < 0.1% |
| 499.95001 | 2510 | |
| 499.75 | 12 | < 0.1% |
| 495 | 14 | < 0.1% |
| 474.95001 | 15 | < 0.1% |
sales_actual
Real number (ℝ)
High correlation 
| Distinct | 2927 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 183.10761 |
| Minimum | 7.49 |
|---|---|
| Maximum | 1939.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 7.49 |
|---|---|
| 5-th percentile | 41.5 |
| Q1 | 104.38 |
| median | 163.99001 |
| Q3 | 247.39999 |
| 95-th percentile | 383.98001 |
| Maximum | 1939.99 |
| Range | 1932.5 |
| Interquartile range (IQR) | 143.01999 |
Descriptive statistics
| Standard deviation | 120.04367 |
|---|---|
| Coefficient of variation (CV) | 0.65559083 |
| Kurtosis | 23.920362 |
| Mean | 183.10761 |
| Median Absolute Deviation (MAD) | 67.00001 |
| Skewness | 2.8884461 |
| Sum | 33054402 |
| Variance | 14410.483 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 122.84 | 1264 | 0.7% |
| 109.19 | 1247 | 0.7% |
| 124.79 | 1243 | 0.7% |
| 129.99001 | 1243 | 0.7% |
| 116.99 | 1243 | 0.7% |
| 123.49 | 1243 | 0.7% |
| 120.89 | 1243 | 0.7% |
| 127.39 | 1243 | 0.7% |
| 97.49 | 1243 | 0.7% |
| 118.29 | 1243 | 0.7% |
| Other values (2917) | 168064 |
| Value | Count | Frequency (%) |
| 7.49 | 3 | < 0.1% |
| 7.99 | 3 | < 0.1% |
| 8.19 | 3 | < 0.1% |
| 8.29 | 3 | < 0.1% |
| 8.39 | 3 | < 0.1% |
| 8.47 | 15 | |
| 8.49 | 3 | < 0.1% |
| 8.66 | 29 | |
| 8.69 | 3 | < 0.1% |
| 8.79 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1939.98999 | 1 | |
| 1919.98999 | 1 | |
| 1899.98999 | 1 | |
| 1889.98999 | 1 | |
| 1859.98999 | 1 | |
| 1819.98999 | 1 | |
| 1799.98999 | 1 | |
| 1759.98999 | 1 | |
| 1739.98999 | 1 | |
| 1699.98999 | 1 |
profit_per_order
Real number (ℝ)
| Distinct | 21998 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.974989 |
| Minimum | -4274.98 |
|---|---|
| Maximum | 911.8 |
| Zeros | 1177 |
| Zeros (%) | 0.7% |
| Negative | 33784 |
| Negative (%) | 18.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -4274.98 |
|---|---|
| 5-th percentile | -139.251 |
| Q1 | 7 |
| median | 31.52 |
| Q3 | 64.8 |
| 95-th percentile | 132.29 |
| Maximum | 911.8 |
| Range | 5186.78 |
| Interquartile range (IQR) | 57.8 |
Descriptive statistics
| Standard deviation | 104.43353 |
|---|---|
| Coefficient of variation (CV) | 4.7523813 |
| Kurtosis | 71.377259 |
| Mean | 21.974989 |
| Median Absolute Deviation (MAD) | 27.88 |
| Skewness | -4.7418341 |
| Sum | 3966903 |
| Variance | 10906.361 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1177 | 0.7% |
| 143.99 | 199 | 0.1% |
| 72 | 194 | 0.1% |
| 46.8 | 188 | 0.1% |
| 24 | 181 | 0.1% |
| 18 | 175 | 0.1% |
| 63.7 | 172 | 0.1% |
| 62.4 | 168 | 0.1% |
| 12 | 166 | 0.1% |
| 14.4 | 166 | 0.1% |
| Other values (21988) | 177733 |
| Value | Count | Frequency (%) |
| -4274.98 | 1 | |
| -3442.5 | 1 | |
| -3366 | 1 | |
| -3000 | 1 | |
| -2592 | 1 | |
| -2550 | 1 | |
| -2351.25 | 1 | |
| -2328 | 1 | |
| -2280 | 1 | |
| -2255.25 | 1 |
| Value | Count | Frequency (%) |
| 911.8 | 1 | |
| 864 | 1 | |
| 721.6 | 1 | |
| 720.3 | 1 | |
| 720 | 2 | |
| 712.95 | 1 | |
| 708.75 | 1 | |
| 705.6 | 2 | |
| 705 | 1 | |
| 698.4 | 2 |
customer_segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.3 MiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.839064 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Consumer |
| 4th row | Home Office |
| 5th row | Corporate |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 93504 | |
| Corporate | 54789 | |
| Home Office | 32226 | 17.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 93504 | |
| corporate | 54789 | |
| home | 32226 | 15.1% |
| office | 32226 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 235308 | |
| e | 212745 | |
| r | 203082 | |
| C | 148293 | |
| m | 125730 | |
| n | 93504 | 5.9% |
| s | 93504 | 5.9% |
| u | 93504 | 5.9% |
| f | 64452 | 4.0% |
| t | 54789 | 3.4% |
| Other values (7) | 270708 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1595619 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 235308 | |
| e | 212745 | |
| r | 203082 | |
| C | 148293 | |
| m | 125730 | |
| n | 93504 | 5.9% |
| s | 93504 | 5.9% |
| u | 93504 | 5.9% |
| f | 64452 | 4.0% |
| t | 54789 | 3.4% |
| Other values (7) | 270708 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1595619 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 235308 | |
| e | 212745 | |
| r | 203082 | |
| C | 148293 | |
| m | 125730 | |
| n | 93504 | 5.9% |
| s | 93504 | 5.9% |
| u | 93504 | 5.9% |
| f | 64452 | 4.0% |
| t | 54789 | 3.4% |
| Other values (7) | 270708 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1595619 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 235308 | |
| e | 212745 | |
| r | 203082 | |
| C | 148293 | |
| m | 125730 | |
| n | 93504 | 5.9% |
| s | 93504 | 5.9% |
| u | 93504 | 5.9% |
| f | 64452 | 4.0% |
| t | 54789 | 3.4% |
| Other values (7) | 270708 |
order_city
Text
| Distinct | 3596 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.3 MiB |
Length
| Max length | 35 |
|---|---|
| Median length | 29 |
| Mean length | 8.553781 |
| Min length | 2 |
Unique
| Unique | 69 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Bekasi |
|---|---|
| 2nd row | Bikaner |
| 3rd row | Bikaner |
| 4th row | Townsville |
| 5th row | Townsville |
| Value | Count | Frequency (%) |
| san | 6508 | 2.9% |
| city | 5626 | 2.5% |
| de | 3211 | 1.4% |
| los | 2435 | 1.1% |
| santo | 2339 | 1.0% |
| new | 2316 | 1.0% |
| york | 2316 | 1.0% |
| domingo | 2239 | 1.0% |
| angeles | 1873 | 0.8% |
| tegucigalpa | 1783 | 0.8% |
| Other values (3762) | 197254 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 203359 | 13.2% |
| e | 117976 | 7.6% |
| n | 115253 | 7.5% |
| o | 113469 | 7.3% |
| i | 98628 | 6.4% |
| r | 85703 | 5.6% |
| l | 76707 | 5.0% |
| u | 59359 | 3.8% |
| t | 56384 | 3.7% |
| s | 56123 | 3.6% |
| Other values (50) | 561159 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1544120 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 203359 | 13.2% |
| e | 117976 | 7.6% |
| n | 115253 | 7.5% |
| o | 113469 | 7.3% |
| i | 98628 | 6.4% |
| r | 85703 | 5.6% |
| l | 76707 | 5.0% |
| u | 59359 | 3.8% |
| t | 56384 | 3.7% |
| s | 56123 | 3.6% |
| Other values (50) | 561159 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1544120 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 203359 | 13.2% |
| e | 117976 | 7.6% |
| n | 115253 | 7.5% |
| o | 113469 | 7.3% |
| i | 98628 | 6.4% |
| r | 85703 | 5.6% |
| l | 76707 | 5.0% |
| u | 59359 | 3.8% |
| t | 56384 | 3.7% |
| s | 56123 | 3.6% |
| Other values (50) | 561159 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1544120 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 203359 | 13.2% |
| e | 117976 | 7.6% |
| n | 115253 | 7.5% |
| o | 113469 | 7.3% |
| i | 98628 | 6.4% |
| r | 85703 | 5.6% |
| l | 76707 | 5.0% |
| u | 59359 | 3.8% |
| t | 56384 | 3.7% |
| s | 56123 | 3.6% |
| Other values (50) | 561159 |
order_country
Text
| Distinct | 164 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.3 MiB |
Length
| Max length | 31 |
|---|---|
| Median length | 22 |
| Mean length | 8.7728272 |
| Min length | 4 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Indonesia |
|---|---|
| 2nd row | India |
| 3rd row | India |
| 4th row | Australia |
| 5th row | Australia |
| Value | Count | Frequency (%) |
| unidos | 24869 | 10.8% |
| estados | 24840 | 10.8% |
| francia | 13222 | 5.7% |
| mexico | 13172 | 5.7% |
| alemania | 9564 | 4.1% |
| australia | 8497 | 3.7% |
| brasil | 7987 | 3.5% |
| reino | 7302 | 3.2% |
| unido | 7302 | 3.2% |
| china | 5758 | 2.5% |
| Other values (175) | 108034 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 248092 | |
| i | 173374 | 10.9% |
| n | 123666 | 7.8% |
| s | 117962 | 7.4% |
| o | 110463 | 7.0% |
| d | 83403 | 5.3% |
| e | 67560 | 4.3% |
| r | 66669 | 4.2% |
| l | 62119 | 3.9% |
| t | 50532 | 3.2% |
| Other values (44) | 479822 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1583662 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 248092 | |
| i | 173374 | 10.9% |
| n | 123666 | 7.8% |
| s | 117962 | 7.4% |
| o | 110463 | 7.0% |
| d | 83403 | 5.3% |
| e | 67560 | 4.3% |
| r | 66669 | 4.2% |
| l | 62119 | 3.9% |
| t | 50532 | 3.2% |
| Other values (44) | 479822 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1583662 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 248092 | |
| i | 173374 | 10.9% |
| n | 123666 | 7.8% |
| s | 117962 | 7.4% |
| o | 110463 | 7.0% |
| d | 83403 | 5.3% |
| e | 67560 | 4.3% |
| r | 66669 | 4.2% |
| l | 62119 | 3.9% |
| t | 50532 | 3.2% |
| Other values (44) | 479822 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1583662 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 248092 | |
| i | 173374 | 10.9% |
| n | 123666 | 7.8% |
| s | 117962 | 7.4% |
| o | 110463 | 7.0% |
| d | 83403 | 5.3% |
| e | 67560 | 4.3% |
| r | 66669 | 4.2% |
| l | 62119 | 3.9% |
| t | 50532 | 3.2% |
| Other values (44) | 479822 |
order_region
Categorical
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.0 MiB |
| Central America | |
|---|---|
| Western Europe | |
| South America | |
| Oceania | |
| Northern Europe | |
| Other values (18) |
Length
| Max length | 15 |
|---|---|
| Median length | 14 |
| Mean length | 12.535007 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Southeast Asia |
|---|---|
| 2nd row | South Asia |
| 3rd row | South Asia |
| 4th row | Oceania |
| 5th row | Oceania |
Common Values
| Value | Count | Frequency (%) |
| Central America | 28341 | |
| Western Europe | 27109 | |
| South America | 14935 | 8.3% |
| Oceania | 10148 | 5.6% |
| Northern Europe | 9792 | 5.4% |
| Southeast Asia | 9539 | 5.3% |
| Southern Europe | 9431 | 5.2% |
| Caribbean | 8318 | 4.6% |
| West of USA | 7993 | 4.4% |
| South Asia | 7731 | 4.3% |
| Other values (13) | 47182 |
Length
| Value | Count | Frequency (%) |
| europe | 50252 | |
| america | 43276 | |
| asia | 31112 | 8.6% |
| central | 30571 | 8.5% |
| western | 27109 | 7.5% |
| south | 26711 | 7.4% |
| of | 18953 | 5.3% |
| usa | 18953 | 5.3% |
| west | 17698 | 4.9% |
| africa | 11614 | 3.2% |
| Other values (11) | 84317 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 267374 | 11.8% |
| r | 221631 | 9.8% |
| a | 185888 | 8.2% |
| 184092 | 8.1% | |
| t | 170633 | 7.5% |
| o | 129067 | 5.7% |
| n | 114572 | 5.1% |
| s | 105425 | 4.7% |
| A | 104955 | 4.6% |
| i | 104468 | 4.6% |
| Other values (16) | 674702 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2262807 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 267374 | 11.8% |
| r | 221631 | 9.8% |
| a | 185888 | 8.2% |
| 184092 | 8.1% | |
| t | 170633 | 7.5% |
| o | 129067 | 5.7% |
| n | 114572 | 5.1% |
| s | 105425 | 4.7% |
| A | 104955 | 4.6% |
| i | 104468 | 4.6% |
| Other values (16) | 674702 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2262807 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 267374 | 11.8% |
| r | 221631 | 9.8% |
| a | 185888 | 8.2% |
| 184092 | 8.1% | |
| t | 170633 | 7.5% |
| o | 129067 | 5.7% |
| n | 114572 | 5.1% |
| s | 105425 | 4.7% |
| A | 104955 | 4.6% |
| i | 104468 | 4.6% |
| Other values (16) | 674702 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2262807 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 267374 | 11.8% |
| r | 221631 | 9.8% |
| a | 185888 | 8.2% |
| 184092 | 8.1% | |
| t | 170633 | 7.5% |
| o | 129067 | 5.7% |
| n | 114572 | 5.1% |
| s | 105425 | 4.7% |
| A | 104955 | 4.6% |
| i | 104468 | 4.6% |
| Other values (16) | 674702 |
order_state
Text
| Distinct | 1089 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.7 MiB |
Length
| Max length | 36 |
|---|---|
| Median length | 31 |
| Mean length | 10.868086 |
| Min length | 3 |
Unique
| Unique | 16 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Java Occidental |
|---|---|
| 2nd row | Rajastan |
| 3rd row | Rajastan |
| 4th row | Queensland |
| 5th row | Queensland |
| Value | Count | Frequency (%) |
| de | 9121 | 3.5% |
| del | 8417 | 3.2% |
| inglaterra | 6722 | 2.6% |
| california | 5580 | 2.1% |
| nueva | 5473 | 2.1% |
| isla | 4667 | 1.8% |
| francia | 4580 | 1.7% |
| san | 3965 | 1.5% |
| sur | 3354 | 1.3% |
| renania | 3303 | 1.3% |
| Other values (1167) | 208183 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 322907 | |
| n | 145815 | 7.4% |
| i | 143282 | 7.3% |
| e | 134534 | 6.9% |
| o | 119614 | 6.1% |
| r | 117395 | 6.0% |
| l | 103549 | 5.3% |
| 82846 | 4.2% | |
| t | 80118 | 4.1% |
| s | 75596 | 3.9% |
| Other values (49) | 636240 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1961896 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 322907 | |
| n | 145815 | 7.4% |
| i | 143282 | 7.3% |
| e | 134534 | 6.9% |
| o | 119614 | 6.1% |
| r | 117395 | 6.0% |
| l | 103549 | 5.3% |
| 82846 | 4.2% | |
| t | 80118 | 4.1% |
| s | 75596 | 3.9% |
| Other values (49) | 636240 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1961896 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 322907 | |
| n | 145815 | 7.4% |
| i | 143282 | 7.3% |
| e | 134534 | 6.9% |
| o | 119614 | 6.1% |
| r | 117395 | 6.0% |
| l | 103549 | 5.3% |
| 82846 | 4.2% | |
| t | 80118 | 4.1% |
| s | 75596 | 3.9% |
| Other values (49) | 636240 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1961896 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 322907 | |
| n | 145815 | 7.4% |
| i | 143282 | 7.3% |
| e | 134534 | 6.9% |
| o | 119614 | 6.1% |
| r | 117395 | 6.0% |
| l | 103549 | 5.3% |
| 82846 | 4.2% | |
| t | 80118 | 4.1% |
| s | 75596 | 3.9% |
| Other values (49) | 636240 |
order_status
Categorical
High correlation 
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.5 MiB |
| COMPLETE | |
|---|---|
| PENDING_PAYMENT | |
| PROCESSING | |
| PENDING | |
| CLOSED | |
| Other values (4) |
Length
| Max length | 15 |
|---|---|
| Median length | 14 |
| Mean length | 9.6239676 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | COMPLETE |
|---|---|
| 2nd row | PENDING |
| 3rd row | CLOSED |
| 4th row | COMPLETE |
| 5th row | PENDING_PAYMENT |
Common Values
| Value | Count | Frequency (%) |
| COMPLETE | 59491 | |
| PENDING_PAYMENT | 39832 | |
| PROCESSING | 21902 | 12.1% |
| PENDING | 20227 | 11.2% |
| CLOSED | 19616 | 10.9% |
| ON_HOLD | 9804 | 5.4% |
| SUSPECTED_FRAUD | 4062 | 2.3% |
| CANCELED | 3692 | 2.0% |
| PAYMENT_REVIEW | 1893 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| complete | 59491 | |
| pending_payment | 39832 | |
| processing | 21902 | 12.1% |
| pending | 20227 | 11.2% |
| closed | 19616 | 10.9% |
| on_hold | 9804 | 5.4% |
| suspected_fraud | 4062 | 2.3% |
| canceled | 3692 | 2.0% |
| payment_review | 1893 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 281578 | |
| N | 197241 | |
| P | 187239 | |
| O | 120617 | 6.9% |
| C | 112455 | 6.5% |
| T | 105278 | 6.1% |
| D | 101295 | 5.8% |
| M | 101216 | 5.8% |
| L | 92603 | 5.3% |
| I | 83854 | 4.8% |
| Other values (11) | 353933 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1737309 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 281578 | |
| N | 197241 | |
| P | 187239 | |
| O | 120617 | 6.9% |
| C | 112455 | 6.5% |
| T | 105278 | 6.1% |
| D | 101295 | 5.8% |
| M | 101216 | 5.8% |
| L | 92603 | 5.3% |
| I | 83854 | 4.8% |
| Other values (11) | 353933 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1737309 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 281578 | |
| N | 197241 | |
| P | 187239 | |
| O | 120617 | 6.9% |
| C | 112455 | 6.5% |
| T | 105278 | 6.1% |
| D | 101295 | 5.8% |
| M | 101216 | 5.8% |
| L | 92603 | 5.3% |
| I | 83854 | 4.8% |
| Other values (11) | 353933 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1737309 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 281578 | |
| N | 197241 | |
| P | 187239 | |
| O | 120617 | 6.9% |
| C | 112455 | 6.5% |
| T | 105278 | 6.1% |
| D | 101295 | 5.8% |
| M | 101216 | 5.8% |
| L | 92603 | 5.3% |
| I | 83854 | 4.8% |
| Other values (11) | 353933 |
order_item_qty
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.0 MiB |
| 1 | |
|---|---|
| 5 | |
| 3 | |
| 4 | |
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 180519 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 180519 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 180519 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
discount
Real number (ℝ)
High correlation  Zeros 
| Distinct | 1017 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.664741 |
| Minimum | 0 |
|---|---|
| Maximum | 500 |
| Zeros | 10028 |
| Zeros (%) | 5.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5.4 |
| median | 14 |
| Q3 | 29.99 |
| 95-th percentile | 62.5 |
| Maximum | 500 |
| Range | 500 |
| Interquartile range (IQR) | 24.59 |
Descriptive statistics
| Standard deviation | 21.800901 |
|---|---|
| Coefficient of variation (CV) | 1.0549806 |
| Kurtosis | 25.231267 |
| Mean | 20.664741 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 3.0397955 |
| Sum | 3730378.4 |
| Variance | 475.27928 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10028 | 5.6% |
| 6 | 4589 | 2.5% |
| 12 | 4067 | 2.3% |
| 4 | 3647 | 2.0% |
| 8 | 3626 | 2.0% |
| 10 | 3424 | 1.9% |
| 36 | 3268 | 1.8% |
| 30 | 3230 | 1.8% |
| 20 | 3123 | 1.7% |
| 9 | 2964 | 1.6% |
| Other values (1007) | 138553 |
| Value | Count | Frequency (%) |
| 0 | 10028 | |
| 0.1 | 3 | < 0.1% |
| 0.11 | 15 | < 0.1% |
| 0.12 | 29 | < 0.1% |
| 0.15 | 7 | < 0.1% |
| 0.16 | 7 | < 0.1% |
| 0.18 | 3 | < 0.1% |
| 0.2 | 16 | < 0.1% |
| 0.22 | 6 | < 0.1% |
| 0.23 | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 500 | 1 | < 0.1% |
| 400 | 1 | < 0.1% |
| 375 | 25 | |
| 360 | 1 | < 0.1% |
| 340 | 1 | < 0.1% |
| 320 | 1 | < 0.1% |
| 300 | 26 | |
| 270 | 25 | |
| 260 | 1 | < 0.1% |
| 255 | 25 |
discount_rate
Real number (ℝ)
High correlation  Zeros 
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.10166819 |
| Minimum | 0 |
|---|---|
| Maximum | 0.25 |
| Zeros | 10028 |
| Zeros (%) | 5.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.04 |
| median | 0.1 |
| Q3 | 0.16 |
| 95-th percentile | 0.25 |
| Maximum | 0.25 |
| Range | 0.25 |
| Interquartile range (IQR) | 0.12 |
Descriptive statistics
| Standard deviation | 0.070415215 |
|---|---|
| Coefficient of variation (CV) | 0.69259829 |
| Kurtosis | -0.90115683 |
| Mean | 0.10166819 |
| Median Absolute Deviation (MAD) | 0.06 |
| Skewness | 0.3409276 |
| Sum | 18353.04 |
| Variance | 0.0049583024 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.04 | 10029 | 5.6% |
| 0.15 | 10029 | 5.6% |
| 0.25 | 10029 | 5.6% |
| 0.2 | 10029 | 5.6% |
| 0.18 | 10029 | 5.6% |
| 0.17 | 10029 | 5.6% |
| 0.05 | 10029 | 5.6% |
| 0.16 | 10029 | 5.6% |
| 0.13 | 10029 | 5.6% |
| 0.12 | 10029 | 5.6% |
| Other values (8) | 80229 |
| Value | Count | Frequency (%) |
| 0 | 10028 | |
| 0.01 | 10028 | |
| 0.02 | 10028 | |
| 0.03 | 10029 | |
| 0.04 | 10029 | |
| 0.05 | 10029 | |
| 0.06 | 10029 | |
| 0.07 | 10029 | |
| 0.09 | 10029 | |
| 0.1 | 10029 |
| Value | Count | Frequency (%) |
| 0.25 | 10029 | |
| 0.2 | 10029 | |
| 0.18 | 10029 | |
| 0.17 | 10029 | |
| 0.16 | 10029 | |
| 0.15 | 10029 | |
| 0.13 | 10029 | |
| 0.12 | 10029 | |
| 0.1 | 10029 | |
| 0.09 | 10029 |
product_id
Real number (ℝ)
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.851451 |
| Minimum | 2 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 18 |
| median | 29 |
| Q3 | 45 |
| 95-th percentile | 48 |
| Maximum | 76 |
| Range | 74 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 15.640064 |
|---|---|
| Coefficient of variation (CV) | 0.49103145 |
| Kurtosis | -0.60326101 |
| Mean | 31.851451 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 0.3616248 |
| Sum | 5749792 |
| Variance | 244.6116 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17 | 24551 | |
| 18 | 22246 | |
| 24 | 21035 | |
| 46 | 19298 | |
| 45 | 17325 | |
| 48 | 15540 | |
| 43 | 13729 | |
| 9 | 12487 | |
| 29 | 10984 | |
| 37 | 2029 | 1.1% |
| Other values (41) | 21295 |
| Value | Count | Frequency (%) |
| 2 | 138 | 0.1% |
| 3 | 632 | 0.4% |
| 4 | 67 | < 0.1% |
| 5 | 343 | 0.2% |
| 6 | 328 | 0.2% |
| 7 | 614 | 0.3% |
| 9 | 12487 | |
| 10 | 111 | 0.1% |
| 11 | 309 | 0.2% |
| 12 | 423 | 0.2% |
| Value | Count | Frequency (%) |
| 76 | 650 | |
| 75 | 838 | |
| 74 | 529 | |
| 73 | 357 | |
| 72 | 492 | |
| 71 | 434 | |
| 70 | 208 | 0.1% |
| 69 | 362 | |
| 68 | 484 | |
| 67 | 483 |
product_name
Text
| Distinct | 118 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.9 MiB |
Length
| Max length | 45 |
|---|---|
| Median length | 43 |
| Mean length | 35.110177 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Smart watch |
|---|---|
| 2nd row | Smart watch |
| 3rd row | Smart watch |
| 4th row | Smart watch |
| 5th row | Smart watch |
| Value | Count | Frequency (%) |
| men's | 77602 | 7.3% |
| nike | 57309 | 5.4% |
| perfect | 49030 | 4.6% |
| golf | 26281 | 2.5% |
| rip | 24515 | 2.3% |
| deck | 24515 | 2.3% |
| fitness | 24515 | 2.3% |
| cleat | 22813 | 2.1% |
| 2 | 22574 | 2.1% |
| elite | 22309 | 2.1% |
| Other values (351) | 715106 |
Most occurring characters
| Value | Count | Frequency (%) |
| 886050 | 14.0% | |
| e | 733504 | 11.6% |
| i | 378177 | 6.0% |
| n | 350567 | 5.5% |
| r | 340664 | 5.4% |
| o | 293733 | 4.6% |
| t | 274503 | 4.3% |
| s | 263028 | 4.1% |
| l | 230952 | 3.6% |
| a | 230847 | 3.6% |
| Other values (56) | 2356029 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6338054 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 886050 | 14.0% | |
| e | 733504 | 11.6% |
| i | 378177 | 6.0% |
| n | 350567 | 5.5% |
| r | 340664 | 5.4% |
| o | 293733 | 4.6% |
| t | 274503 | 4.3% |
| s | 263028 | 4.1% |
| l | 230952 | 3.6% |
| a | 230847 | 3.6% |
| Other values (56) | 2356029 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6338054 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 886050 | 14.0% | |
| e | 733504 | 11.6% |
| i | 378177 | 6.0% |
| n | 350567 | 5.5% |
| r | 340664 | 5.4% |
| o | 293733 | 4.6% |
| t | 274503 | 4.3% |
| s | 263028 | 4.1% |
| l | 230952 | 3.6% |
| a | 230847 | 3.6% |
| Other values (56) | 2356029 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6338054 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 886050 | 14.0% | |
| e | 733504 | 11.6% |
| i | 378177 | 6.0% |
| n | 350567 | 5.5% |
| r | 340664 | 5.4% |
| o | 293733 | 4.6% |
| t | 274503 | 4.3% |
| s | 263028 | 4.1% |
| l | 230952 | 3.6% |
| a | 230847 | 3.6% |
| Other values (56) | 2356029 |
product_price
Real number (ℝ)
High correlation 
| Distinct | 75 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 141.23255 |
| Minimum | 9.99 |
|---|---|
| Maximum | 1999.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 9.99 |
|---|---|
| 5-th percentile | 31.99 |
| Q1 | 50 |
| median | 59.99 |
| Q3 | 199.99 |
| 95-th percentile | 399.98 |
| Maximum | 1999.99 |
| Range | 1990 |
| Interquartile range (IQR) | 149.99 |
Descriptive statistics
| Standard deviation | 139.73249 |
|---|---|
| Coefficient of variation (CV) | 0.98937881 |
| Kurtosis | 23.313 |
| Mean | 141.23255 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 3.1910197 |
| Sum | 25495158 |
| Variance | 19525.168 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.99 | 24820 | |
| 129.99 | 22372 | |
| 50 | 21035 | |
| 49.98 | 19298 | |
| 399.98 | 17325 | |
| 199.99 | 15622 | |
| 299.98 | 13729 | |
| 99.99 | 12433 | |
| 39.99 | 11201 | |
| 24.99 | 2339 | 1.3% |
| Other values (65) | 20345 |
| Value | Count | Frequency (%) |
| 9.99 | 285 | 0.2% |
| 11.29 | 271 | 0.2% |
| 11.54 | 529 | 0.3% |
| 14.99 | 593 | 0.3% |
| 15.99 | 602 | 0.3% |
| 17.99 | 298 | 0.2% |
| 19.99 | 887 | 0.5% |
| 21.99 | 295 | 0.2% |
| 22 | 308 | 0.2% |
| 24.99 | 2339 |
| Value | Count | Frequency (%) |
| 1999.99 | 15 | < 0.1% |
| 1500 | 442 | 0.2% |
| 999.99 | 10 | < 0.1% |
| 599.99 | 21 | < 0.1% |
| 532.58 | 484 | 0.3% |
| 461.48 | 484 | 0.3% |
| 452.04 | 592 | 0.3% |
| 399.99 | 67 | < 0.1% |
| 399.98 | 17325 | |
| 357.1 | 652 | 0.4% |
Interactions
Correlations
| customer_segment | delivery_status | discount | discount_rate | late_delivery_risk | order_item_qty | order_region | order_status | product_id | product_price | profit_per_order | sales_actual | sales_origin | shipping_days_actual | shipping_days_scheduled | shipping_mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_segment | 1.000 | 0.005 | 0.002 | 0.002 | 0.000 | 0.004 | 0.017 | 0.011 | 0.008 | 0.002 | 0.000 | 0.006 | 0.004 | 0.009 | 0.008 | 0.008 |
| delivery_status | 0.005 | 1.000 | 0.000 | 0.003 | 1.000 | 0.000 | 0.018 | 0.577 | 0.000 | 0.000 | 0.000 | 0.005 | 0.000 | 0.561 | 0.321 | 0.321 |
| discount | 0.002 | 0.000 | 1.000 | 0.795 | 0.000 | 0.082 | 0.018 | 0.000 | 0.073 | 0.356 | 0.196 | 0.420 | 0.534 | 0.001 | 0.000 | 0.000 |
| discount_rate | 0.002 | 0.003 | 0.795 | 1.000 | 0.005 | 0.000 | 0.000 | 0.003 | 0.000 | 0.000 | -0.054 | -0.133 | 0.000 | 0.001 | 0.000 | 0.000 |
| late_delivery_risk | 0.000 | 1.000 | 0.000 | 0.005 | 1.000 | 0.000 | 0.017 | 0.234 | 0.000 | 0.004 | 0.000 | 0.000 | 0.002 | 0.631 | 0.457 | 0.457 |
| order_item_qty | 0.004 | 0.000 | 0.082 | 0.000 | 0.000 | 1.000 | 0.031 | 0.000 | 0.232 | 0.229 | 0.034 | 0.212 | 0.235 | 0.000 | 0.002 | 0.002 |
| order_region | 0.017 | 0.018 | 0.018 | 0.000 | 0.017 | 0.031 | 1.000 | 0.017 | 0.118 | 0.060 | 0.014 | 0.026 | 0.042 | 0.022 | 0.023 | 0.023 |
| order_status | 0.011 | 0.577 | 0.000 | 0.003 | 0.234 | 0.000 | 0.017 | 1.000 | 0.001 | 0.003 | 0.000 | 0.006 | 0.004 | 0.008 | 0.009 | 0.009 |
| product_id | 0.008 | 0.000 | 0.073 | 0.000 | 0.000 | 0.232 | 0.118 | 0.001 | 1.000 | 0.195 | 0.061 | 0.162 | 0.178 | -0.002 | 0.009 | 0.009 |
| product_price | 0.002 | 0.000 | 0.356 | 0.000 | 0.004 | 0.229 | 0.060 | 0.003 | 0.195 | 1.000 | 0.287 | 0.639 | 0.667 | -0.000 | 0.008 | 0.008 |
| profit_per_order | 0.000 | 0.000 | 0.196 | -0.054 | 0.000 | 0.034 | 0.014 | 0.000 | 0.061 | 0.287 | 1.000 | 0.441 | 0.436 | -0.003 | 0.002 | 0.002 |
| sales_actual | 0.006 | 0.005 | 0.420 | -0.133 | 0.000 | 0.212 | 0.026 | 0.006 | 0.162 | 0.639 | 0.441 | 1.000 | 0.986 | -0.000 | 0.004 | 0.004 |
| sales_origin | 0.004 | 0.000 | 0.534 | 0.000 | 0.002 | 0.235 | 0.042 | 0.004 | 0.178 | 0.667 | 0.436 | 0.986 | 1.000 | -0.000 | 0.006 | 0.006 |
| shipping_days_actual | 0.009 | 0.561 | 0.001 | 0.001 | 0.631 | 0.000 | 0.022 | 0.008 | -0.002 | -0.000 | -0.003 | -0.000 | -0.000 | 1.000 | 0.681 | 0.681 |
| shipping_days_scheduled | 0.008 | 0.321 | 0.000 | 0.000 | 0.457 | 0.002 | 0.023 | 0.009 | 0.009 | 0.008 | 0.002 | 0.004 | 0.006 | 0.681 | 1.000 | 1.000 |
| shipping_mode | 0.008 | 0.321 | 0.000 | 0.000 | 0.457 | 0.002 | 0.023 | 0.009 | 0.009 | 0.008 | 0.002 | 0.004 | 0.006 | 0.681 | 1.000 | 1.000 |
Missing values
Sample
| order_date | shipping_date | shipping_mode | delivery_status | shipping_days_actual | shipping_days_scheduled | late_delivery_risk | sales_origin | sales_actual | profit_per_order | customer_segment | order_city | order_country | order_region | order_state | order_status | order_item_qty | discount | discount_rate | product_id | product_name | product_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2018-01-31 | 2018-02-03 | Standard Class | Advance shipping | 3 | 4 | 0 | 327.75 | 314.64001 | 91.25 | Consumer | Bekasi | Indonesia | Southeast Asia | Java Occidental | COMPLETE | 1 | 13.11 | 0.04 | 73 | Smart watch | 327.75 |
| 1 | 2018-01-13 | 2018-01-18 | Standard Class | Late delivery | 5 | 4 | 1 | 327.75 | 311.35999 | -249.09 | Consumer | Bikaner | India | South Asia | Rajastan | PENDING | 1 | 16.39 | 0.05 | 73 | Smart watch | 327.75 |
| 2 | 2018-01-13 | 2018-01-17 | Standard Class | Shipping on time | 4 | 4 | 0 | 327.75 | 309.72000 | -247.78 | Consumer | Bikaner | India | South Asia | Rajastan | CLOSED | 1 | 18.03 | 0.06 | 73 | Smart watch | 327.75 |
| 3 | 2018-01-13 | 2018-01-16 | Standard Class | Advance shipping | 3 | 4 | 0 | 327.75 | 304.81000 | 22.86 | Home Office | Townsville | Australia | Oceania | Queensland | COMPLETE | 1 | 22.94 | 0.07 | 73 | Smart watch | 327.75 |
| 4 | 2018-01-13 | 2018-01-15 | Standard Class | Advance shipping | 2 | 4 | 0 | 327.75 | 298.25000 | 134.21 | Corporate | Townsville | Australia | Oceania | Queensland | PENDING_PAYMENT | 1 | 29.50 | 0.09 | 73 | Smart watch | 327.75 |
| 5 | 2018-01-13 | 2018-01-19 | Standard Class | Shipping canceled | 6 | 4 | 0 | 327.75 | 294.98001 | 18.58 | Consumer | Toowoomba | Australia | Oceania | Queensland | CANCELED | 1 | 32.78 | 0.10 | 73 | Smart watch | 327.75 |
| 6 | 2018-01-13 | 2018-01-15 | First Class | Late delivery | 2 | 1 | 1 | 327.75 | 288.42001 | 95.18 | Home Office | Guangzhou | China | Eastern Asia | Guangdong | COMPLETE | 1 | 39.33 | 0.12 | 73 | Smart watch | 327.75 |
| 7 | 2018-01-13 | 2018-01-15 | First Class | Late delivery | 2 | 1 | 1 | 327.75 | 285.14001 | 68.43 | Corporate | Guangzhou | China | Eastern Asia | Guangdong | PROCESSING | 1 | 42.61 | 0.13 | 73 | Smart watch | 327.75 |
| 8 | 2018-01-13 | 2018-01-16 | Second Class | Late delivery | 3 | 2 | 1 | 327.75 | 278.59000 | 133.72 | Corporate | Guangzhou | China | Eastern Asia | Guangdong | CLOSED | 1 | 49.16 | 0.15 | 73 | Smart watch | 327.75 |
| 9 | 2018-01-13 | 2018-01-15 | First Class | Late delivery | 2 | 1 | 1 | 327.75 | 275.31000 | 132.15 | Corporate | Guangzhou | China | Eastern Asia | Guangdong | CLOSED | 1 | 52.44 | 0.16 | 73 | Smart watch | 327.75 |
| order_date | shipping_date | shipping_mode | delivery_status | shipping_days_actual | shipping_days_scheduled | late_delivery_risk | sales_origin | sales_actual | profit_per_order | customer_segment | order_city | order_country | order_region | order_state | order_status | order_item_qty | discount | discount_rate | product_id | product_name | product_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180509 | 2016-01-16 | 2016-01-19 | Standard Class | Advance shipping | 3 | 4 | 0 | 399.98001 | 335.98001 | 0.00 | Corporate | Guangshui | China | Eastern Asia | Hubei | PENDING_PAYMENT | 1 | 64.0 | 0.16 | 45 | Field & Stream Sportsman 16 Gun Fire Safe | 399.98 |
| 180510 | 2016-01-16 | 2016-01-19 | Standard Class | Advance shipping | 3 | 4 | 0 | 399.98001 | 331.98001 | 165.99 | Corporate | Guangshui | China | Eastern Asia | Hubei | PENDING_PAYMENT | 1 | 68.0 | 0.17 | 45 | Field & Stream Sportsman 16 Gun Fire Safe | 399.98 |
| 180511 | 2016-01-16 | 2016-01-18 | Second Class | Shipping on time | 2 | 2 | 0 | 399.98001 | 327.98001 | 157.43 | Consumer | Chengdu | China | Eastern Asia | Sichuan | ON_HOLD | 1 | 72.0 | 0.18 | 45 | Field & Stream Sportsman 16 Gun Fire Safe | 399.98 |
| 180512 | 2016-01-16 | 2016-01-22 | Standard Class | Late delivery | 6 | 4 | 1 | 399.98001 | 319.98001 | 86.40 | Home Office | Chengdu | China | Eastern Asia | Sichuan | COMPLETE | 1 | 80.0 | 0.20 | 45 | Field & Stream Sportsman 16 Gun Fire Safe | 399.98 |
| 180513 | 2016-01-16 | 2016-01-19 | Standard Class | Advance shipping | 3 | 4 | 0 | 399.98001 | 299.98999 | 119.99 | Home Office | Shanghai | China | Eastern Asia | Shanghai | PENDING_PAYMENT | 1 | 100.0 | 0.25 | 45 | Field & Stream Sportsman 16 Gun Fire Safe | 399.98 |
| 180514 | 2016-01-16 | 2016-01-20 | Standard Class | Shipping on time | 4 | 4 | 0 | 399.98001 | 399.98001 | 40.00 | Home Office | Shanghai | China | Eastern Asia | Shanghai | CLOSED | 1 | 0.0 | 0.00 | 45 | Field & Stream Sportsman 16 Gun Fire Safe | 399.98 |
| 180515 | 2016-01-16 | 2016-01-19 | Second Class | Late delivery | 3 | 2 | 1 | 399.98001 | 395.98001 | -613.77 | Corporate | Hirakata | Japon | Eastern Asia | Osaka | COMPLETE | 1 | 4.0 | 0.01 | 45 | Field & Stream Sportsman 16 Gun Fire Safe | 399.98 |
| 180516 | 2016-01-15 | 2016-01-20 | Standard Class | Late delivery | 5 | 4 | 1 | 399.98001 | 391.98001 | 141.11 | Corporate | Adelaide | Australia | Oceania | Australia del Sur | PENDING | 1 | 8.0 | 0.02 | 45 | Field & Stream Sportsman 16 Gun Fire Safe | 399.98 |
| 180517 | 2016-01-15 | 2016-01-18 | Standard Class | Advance shipping | 3 | 4 | 0 | 399.98001 | 387.98001 | 186.23 | Consumer | Adelaide | Australia | Oceania | Australia del Sur | PENDING_PAYMENT | 1 | 12.0 | 0.03 | 45 | Field & Stream Sportsman 16 Gun Fire Safe | 399.98 |
| 180518 | 2016-01-15 | 2016-01-19 | Standard Class | Shipping on time | 4 | 4 | 0 | 399.98001 | 383.98001 | 168.95 | Consumer | Nagercoil | India | South Asia | Tamil Nadu | PENDING_PAYMENT | 1 | 16.0 | 0.04 | 45 | Field & Stream Sportsman 16 Gun Fire Safe | 399.98 |